SELECT *, CASE WHEN `name` LIKE "east northport%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east northport" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east northport" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "east northport" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("east northport") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$6,499,0001381 1387 Pulaski Rd Unit 1387East Northport NY 11731View Listing
$1,500,000239 Cedrus AveEast Northport NY 11731View Listing
$1,199,99996 Bellecrest AveEast Northport NY 11731View Listing
$1,199,00024 Wood Sorrell LnEast Northport NY 11731View Listing
$1,100,00017 Meadow Lark DrEast Northport NY 11731View Listing
$1,100,0001418 Pulaski RdEast Northport NY 11731View Listing
$1,075,00056 Colonial DrEast Northport NY 11731View Listing
$1,075,00056A Colonial StEast Northport NY 11731View Listing
$999,9991236 McFadden DrEast Northport NY 11731View Listing
$989,00022 Wood Sorrell LnEast Northport NY 11731View Listing
$899,9992 Laura LnEast Northport NY 11731View Listing
$899,99928 Elm DrEast Northport NY 11731View Listing
$899,000456 Elwood RdEast Northport NY 11731View Listing
$899,00056 Verleye AveEast Northport NY 11731View Listing
$875,00014 Gerri RdEast Northport NY 11731View Listing
$849,99912 Teresa LnEast Northport NY 11731View Listing
$849,99025 Kimberly DrEast Northport NY 11731View Listing
$799,00031 Roosevelt AveEast Northport NY 11731View Listing
$799,000110 Pulaski RdEast Northport NY 11731View Listing
$749,00010 Greg LnEast Northport NY 11731View Listing
$739,00022 Diane LnEast Northport NY 11731View Listing
$700,00017 Clarissa LnEast Northport NY 11731View Listing
$699,999119 Catherine StEast Northport NY 11731View Listing
$699,9996 Alister CirEast Northport NY 11731View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 8:34:36 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah